# -*- coding: utf-8 -*-
#mysqldb
import time, MySQLdb

#连接
conn=MySQLdb.connect(
    host="10.10.10.197",
    port=3100,
    user="root",
    passwd="oseasydads_db",
    db="banbantong",
    charset="utf8"
)
cursor = conn.cursor()
print type(cursor)
#写入

sql = "insert into role (uuid, name, remark) values ('34CCE3F0-1C81-11E5-849B-000C29997576', '2', '2')"

n = cursor.execute(sql)
conn.commit()
print n
